How to: Prevent hiding/unhiding, renaming, inserting, deleting worksheets.
Solution:
Select 'Protection' from the 'Tools' menu and select 'Protect Workbook...'. Select the 'Structure' check box.
1) Select the 'Tools' menu and select 'Protection'. (A submenu appears.)
2) Select 'Protect Workbook...' from the submenu. (The Protect Workbook dialog box appears.)
3) (Optional) Type a password in the 'Password' box.
4) Select the 'Structure' check box to prevent inserting, deleting, moving, hiding, unhiding, or renaming worksheets in the workbook.
5) Click 'OK'.
NOTE: If a password was entered in Step 3), the 'Confirm Password' dialog box appears.
6) (Optional) Type the same password in the 'Reenter Protection Password' box of the 'Confirm Password' dialog box.
7) (Optional) Click 'OK'.
